
<!DOCTYPE HTML>
<html lang="" >
    <head>
        <meta charset="UTF-8">
        <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
        <title>sharding-jdbc-4.1.1版本启动数据源报错问题 · JAVA学习积累</title>
        <meta http-equiv="X-UA-Compatible" content="IE=edge" />
        <meta name="description" content="">
        <meta name="generator" content="GitBook 3.2.3">
        <meta name="author" content="tianwyam">
        
        
    
    <link rel="stylesheet" href="../gitbook/style.css">

    
            
                
                <link rel="stylesheet" href="../gitbook/gitbook-plugin-tbfed-pagefooter/footer.css">
                
            
                
                <link rel="stylesheet" href="../gitbook/gitbook-plugin-splitter/splitter.css">
                
            
                
                <link rel="stylesheet" href="../gitbook/gitbook-plugin-pageview-count/plugin.css">
                
            
                
                <link rel="stylesheet" href="../gitbook/gitbook-plugin-anchor-navigation-ex/style/plugin.css">
                
            
                
                <link rel="stylesheet" href="../gitbook/gitbook-plugin-chapter-fold/chapter-fold.css">
                
            
                
                <link rel="stylesheet" href="../gitbook/gitbook-plugin-expandable-chapters-small/expandable-chapters-small.css">
                
            
                
                <link rel="stylesheet" href="../gitbook/gitbook-plugin-highlight/website.css">
                
            
                
                <link rel="stylesheet" href="../gitbook/gitbook-plugin-fontsettings/website.css">
                
            
        

    

    
        
    
        
    
        
    
        
    
        
    
        
    

        
    
    
    <meta name="HandheldFriendly" content="true"/>
    <meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no">
    <meta name="apple-mobile-web-app-capable" content="yes">
    <meta name="apple-mobile-web-app-status-bar-style" content="black">
    <link rel="apple-touch-icon-precomposed" sizes="152x152" href="../gitbook/images/apple-touch-icon-precomposed-152.png">
    <link rel="shortcut icon" href="../gitbook/images/favicon.ico" type="image/x-icon">

    
    
    <link rel="prev" href="../tools/github/github_ssh.html" />
    

    </head>
    <body>
        
<div class="book">
    <div class="book-summary">
        
            
            
                <nav role="navigation">
                


<ul class="summary">
    
    
    
        
        <li>
            <a href="https://blog.csdn.net/mybook201314" target="_blank" class="custom-link">博客Blog</a>
        </li>
    
    

    
    <li class="divider"></li>
    

    
        
        <li class="header">【前言】</li>
        
        
    
        <li class="chapter " data-level="1.1" data-path="../">
            
                <a href="../">
            
                    
                    介绍ABOUT
            
                </a>
            

            
        </li>
    

    
        
        <li class="header">【第一章】Java基础</li>
        
        
    
        <li class="chapter " data-level="2.1" data-path="../java/java.html">
            
                <a href="../java/java.html">
            
                    
                    计算机基础-操作系统-进程-计算机网络
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="2.2" data-path="../java/java_thread_pool.html">
            
                <a href="../java/java_thread_pool.html">
            
                    
                    线程池的工作原理
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="2.3" data-path="../java/java_ftp.html">
            
                <a href="../java/java_ftp.html">
            
                    
                    FTP文件服务器上传下载
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="2.4" data-path="../java/collection.html">
            
                <a href="../java/collection.html">
            
                    
                    集合
            
                </a>
            

            
            <ul class="articles">
                
    
        <li class="chapter " data-level="2.4.1" data-path="../java/collection/java_collection_map.html">
            
                <a href="../java/collection/java_collection_map.html">
            
                    
                    Map&HashMap&HashTable&ConcurrentHashMap
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="2.4.2" data-path="../java/java_queue.html">
            
                <a href="../java/java_queue.html">
            
                    
                    队列-queue
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="2.4.3" data-path="../java/java_tree.html">
            
                <a href="../java/java_tree.html">
            
                    
                    二叉树遍历
            
                </a>
            

            
        </li>
    

            </ul>
            
        </li>
    

    
        
        <li class="divider"></li>
        
        
    
        <li class="chapter " data-level="3.1" data-path="../java/java_io_nio.html">
            
                <a href="../java/java_io_nio.html">
            
                    
                    java输入输出流
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="3.2" data-path="../java/java_exception.html">
            
                <a href="../java/java_exception.html">
            
                    
                    异常exception
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="3.3" data-path="../java/java_serialize.html">
            
                <a href="../java/java_serialize.html">
            
                    
                    Java序列化
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="3.4" data-path="../java/Java_annotation.html">
            
                <a href="../java/Java_annotation.html">
            
                    
                    注解
            
                </a>
            

            
        </li>
    

    
        
        <li class="divider"></li>
        
        
    
        <li class="chapter " data-level="4.1" data-path="../java/multi.html">
            
                <a href="../java/multi.html">
            
                    
                    多线程
            
                </a>
            

            
            <ul class="articles">
                
    
        <li class="chapter " data-level="4.1.1" data-path="../java/multithread/java_multi_thread_volatile_synchronized.html">
            
                <a href="../java/multithread/java_multi_thread_volatile_synchronized.html">
            
                    
                    volatile&synchronized
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="4.1.2" data-path="../java/multithread/java_multi_thread_object_wait_notify.html">
            
                <a href="../java/multithread/java_multi_thread_object_wait_notify.html">
            
                    
                    object/wait/notify
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="4.1.3" data-path="../java/multithread/java_multi_thread_thread.html">
            
                <a href="../java/multithread/java_multi_thread_thread.html">
            
                    
                    thread
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="4.1.4" data-path="../java/multithread/java_multi_thread_threadpool.html">
            
                <a href="../java/multithread/java_multi_thread_threadpool.html">
            
                    
                    线程池的工作原理
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="4.1.5" data-path="../java/multithread/java_multi_thread_lock.html">
            
                <a href="../java/multithread/java_multi_thread_lock.html">
            
                    
                    lock&ReentrantLock&ReadWriteLock
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="4.1.6" data-path="../java/multithread/java_multi_thread_lock_condition.html">
            
                <a href="../java/multithread/java_multi_thread_lock_condition.html">
            
                    
                    lock&condition
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="4.1.7" data-path="../java/multithread/java_multi_thread_tools.html">
            
                <a href="../java/multithread/java_multi_thread_tools.html">
            
                    
                    Java并发工具- CountDownLatch&CyclicBarrier 
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="4.1.8" data-path="../java/multithread/java_multi_thread_tools2.html">
            
                <a href="../java/multithread/java_multi_thread_tools2.html">
            
                    
                    Java同步工具类- CountDownLatch&CyclicBarrier&Semaphore  
            
                </a>
            

            
        </li>
    

            </ul>
            
        </li>
    

    
        
        <li class="divider"></li>
        
        
    
        <li class="chapter " data-level="5.1" data-path="../java/java_jvm.html">
            
                <a href="../java/java_jvm.html">
            
                    
                    java虚拟机-JVM
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="5.2" data-path="../java/java_java7new.html">
            
                <a href="../java/java_java7new.html">
            
                    
                    java7新知识- Switch&TWR&Objects 
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="5.3" data-path="../java/java_stream.html">
            
                <a href="../java/java_stream.html">
            
                    
                    Java8对集合流操作stream
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="5.4" data-path="../java/java_stream_groupby.html">
            
                <a href="../java/java_stream_groupby.html">
            
                    
                    java8新语法-Stream-分组groupingBy操作 
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="5.5" data-path="../java/java_optional.html">
            
                <a href="../java/java_optional.html">
            
                    
                    java8新语法-Optional 
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="5.6" data-path="../java/java_8new_date_api.html">
            
                <a href="../java/java_8new_date_api.html">
            
                    
                    java8-新的日期时间API 
            
                </a>
            

            
        </li>
    

    
        
        <li class="divider"></li>
        
        
    
        <li class="chapter " data-level="6.1" data-path="../xml/xml_translation.html">
            
                <a href="../xml/xml_translation.html">
            
                    
                    XML中特殊符号的转译 
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="6.2" data-path="../datastructure/binary_complement.html">
            
                <a href="../datastructure/binary_complement.html">
            
                    
                    原码、反码、补码 
            
                </a>
            

            
        </li>
    

    
        
        <li class="divider"></li>
        
        
    
        <li class="chapter " data-level="7.1" data-path="../java/basic/javabean2map.html">
            
                <a href="../java/basic/javabean2map.html">
            
                    
                    Java bean转Map 
            
                </a>
            

            
        </li>
    

    
        
        <li class="header">【第二章】算法积累题</li>
        
        
    
        <li class="chapter " data-level="8.1" data-path="../algorithm/merge_sorted_array.html">
            
                <a href="../algorithm/merge_sorted_array.html">
            
                    
                    算法题 - 合并排序数组 
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="8.2" data-path="../algorithm/lowest_score.html">
            
                <a href="../algorithm/lowest_score.html">
            
                    
                    算法题 - 最低分数线问题 
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="8.3" data-path="../algorithm/array_sub_list.html">
            
                <a href="../algorithm/array_sub_list.html">
            
                    
                    算法题 - 求数组的子集合 
            
                </a>
            

            
        </li>
    

    
        
        <li class="header">【第三章】框架</li>
        
        
    
        <li class="chapter " data-level="9.1" data-path="../Spring/springboot.html">
            
                <a href="../Spring/springboot.html">
            
                    
                    SpringBoot
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="9.2" data-path="../Spring/spring_security.html">
            
                <a href="../Spring/spring_security.html">
            
                    
                    SpringSecurity
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="9.3" data-path="../linux/linux_commands_springboot_startup.html">
            
                <a href="../linux/linux_commands_springboot_startup.html">
            
                    
                    SpringBoot项目启动脚本
            
                </a>
            

            
        </li>
    

    
        
        <li class="divider"></li>
        
        
    
        <li class="chapter " data-level="10.1" data-path="../Spring/spring/spring_interview_questions_68.html">
            
                <a href="../Spring/spring/spring_interview_questions_68.html">
            
                    
                    Spring面试题68
            
                </a>
            

            
        </li>
    

    
        
        <li class="divider"></li>
        
        
    
        <li class="chapter " data-level="11.1" data-path="../Spring/springboot_auto_config.html">
            
                <a href="../Spring/springboot_auto_config.html">
            
                    
                    SpringBoot自动装载机制 - 源码分析
            
                </a>
            

            
        </li>
    

    
        
        <li class="divider"></li>
        
        
    
        <li class="chapter " data-level="12.1" data-path="../Spring/spring_feign.html">
            
                <a href="../Spring/spring_feign.html">
            
                    
                    Feign在spring、springboot下使用
            
                </a>
            

            
        </li>
    

    
        
        <li class="divider"></li>
        
        
    
        <li class="chapter " data-level="13.1" data-path="../Spring/spring_freemarker.html">
            
                <a href="../Spring/spring_freemarker.html">
            
                    
                    Spring boot集成freemarker，生成word文件
            
                </a>
            

            
        </li>
    

    
        
        <li class="divider"></li>
        
        
    
        <li class="chapter " data-level="14.1" data-path="../Spring/spring_freemarker_generate.html">
            
                <a href="../Spring/spring_freemarker_generate.html">
            
                    
                    Freemarker自动生成Java bean代码
            
                </a>
            

            
        </li>
    

    
        
        <li class="divider"></li>
        
        
    
        <li class="chapter " data-level="15.1" data-path="../mybatis/mybatis_metadata.html">
            
                <a href="../mybatis/mybatis_metadata.html">
            
                    
                    mybatis中操作元数据
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="15.2" data-path="../mybatis/mybatis_batch_exec_sql.html">
            
                <a href="../mybatis/mybatis_batch_exec_sql.html">
            
                    
                    mybatis中insert/update/delete标签中执行多条SQL语句
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="15.3" data-path="../mybatis/mybatis_plus.html">
            
                <a href="../mybatis/mybatis_plus.html">
            
                    
                    springboot集成mybatis-plus框架
            
                </a>
            

            
        </li>
    

    
        
        <li class="divider"></li>
        
        
    
        <li class="chapter " data-level="16.1" data-path="../distributed/sharding-jdbc.html">
            
                <a href="../distributed/sharding-jdbc.html">
            
                    
                    【分布式】sharding-jdbc实现分库分表
            
                </a>
            

            
        </li>
    

    
        
        <li class="header">【第四章】数据库</li>
        
        
    
        <li class="chapter " data-level="17.1" data-path="../SQL/sql.html">
            
                <a href="../SQL/sql.html">
            
                    
                    SQL常用使用
            
                </a>
            

            
        </li>
    

    
        
        <li class="divider"></li>
        
        
    
        <li class="chapter " data-level="18.1" data-path="../redis/redis_study_notes.html">
            
                <a href="../redis/redis_study_notes.html">
            
                    
                    redis学习笔记
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="18.2" data-path="../redis/redis_list_second_kill.html">
            
                <a href="../redis/redis_list_second_kill.html">
            
                    
                    Redis中的队列list实现秒杀活动抢购
            
                </a>
            

            
        </li>
    

    
        
        <li class="divider"></li>
        
        
    
        <li class="chapter " data-level="19.1" data-path="../SQL/sql_mysql_green_install.html">
            
                <a href="../SQL/sql_mysql_green_install.html">
            
                    
                    mysql绿色版安装服务教程
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="19.2" data-path="../SQL/sql_h2.html">
            
                <a href="../SQL/sql_h2.html">
            
                    
                    H2内嵌数据的使用
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="19.3" data-path="../SQL/cache.html">
            
                <a href="../SQL/cache.html">
            
                    
                    缓存
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="19.4" data-path="../SQL/mysql/mysql_back_rollback.html">
            
                <a href="../SQL/mysql/mysql_back_rollback.html">
            
                    
                    MySQL单表备份还原
            
                </a>
            

            
        </li>
    

    
        
        <li class="header">【第五章】Web</li>
        
        
    
        <li class="chapter " data-level="20.1" data-path="../web/web_js_jquery.html">
            
                <a href="../web/web_js_jquery.html">
            
                    
                    web简单积累
            
                </a>
            

            
        </li>
    

    
        
        <li class="header">【第六章】Linux</li>
        
        
    
        <li class="chapter " data-level="21.1" data-path="../linux/linux_common_commands.html">
            
                <a href="../linux/linux_common_commands.html">
            
                    
                    linux常用命令
            
                </a>
            

            
        </li>
    

    
        
        <li class="header">【第七章】Windows</li>
        
        
    
        <li class="chapter " data-level="22.1" data-path="../windows/windows_common_commands.html">
            
                <a href="../windows/windows_common_commands.html">
            
                    
                    windows常用命令
            
                </a>
            

            
        </li>
    

    
        
        <li class="header">【第八章】错误集</li>
        
        
    
        <li class="chapter " data-level="23.1" data-path="maven_not_found_local_jar.html">
            
                <a href="maven_not_found_local_jar.html">
            
                    
                    maven引入依赖时识别不到本地仓库的jar
            
                </a>
            

            
        </li>
    

    
        
        <li class="divider"></li>
        
        
    
        <li class="chapter " data-level="24.1" data-path="security_not_configure_antMatchers_after_anyRequest.html">
            
                <a href="security_not_configure_antMatchers_after_anyRequest.html">
            
                    
                    spring security 配置发生错误 Can't configure antMatchers after anyRequest
            
                </a>
            

            
        </li>
    

    
        
        <li class="divider"></li>
        
        
    
        <li class="chapter " data-level="25.1" data-path="AOP_stream_close_error.html">
            
                <a href="AOP_stream_close_error.html">
            
                    
                    AOP内获取了对请求流操作后报流已经关闭错误的问题
            
                </a>
            

            
        </li>
    

    
        
        <li class="divider"></li>
        
        
    
        <li class="chapter " data-level="26.1" data-path="../tools/github/github_ssh.html">
            
                <a href="../tools/github/github_ssh.html">
            
                    
                    Github ssh key 解决提交后push频繁输入用户名和密码
            
                </a>
            

            
        </li>
    

    
        
        <li class="divider"></li>
        
        
    
        <li class="chapter active" data-level="27.1" data-path="sharding-jdbc-error-datasources.html">
            
                <a href="sharding-jdbc-error-datasources.html">
            
                    
                    sharding-jdbc-4.1.1版本启动数据源报错问题
            
                </a>
            

            
        </li>
    

    

    <li class="divider"></li>

    <li>
        <a href="https://www.gitbook.com" target="blank" class="gitbook-link">
            Published with GitBook
        </a>
    </li>
</ul>


                </nav>
            
        
    </div>

    <div class="book-body">
        
            <div class="body-inner">
                
                    

<div class="book-header" role="navigation">
    

    <!-- Title -->
    <h1>
        <i class="fa fa-circle-o-notch fa-spin"></i>
        <a href=".." >sharding-jdbc-4.1.1版本启动数据源报错问题</a>
    </h1>
</div>




                    <div class="page-wrapper" tabindex="-1" role="main">
                        <div class="page-inner">
                            
                                <section class="normal markdown-section">
                                
                                <div id="anchor-navigation-ex-navbar"><i class="fa fa-navicon"></i><ul><li><span class="title-icon "></span><a href="#sharding-jdbc-411&#x7248;&#x672C;&#x542F;&#x52A8;&#x6570;&#x636E;&#x6E90;&#x62A5;&#x9519;&#x95EE;&#x9898;"><b></b>sharding-jdbc-4.1.1&#x7248;&#x672C;&#x542F;&#x52A8;&#x6570;&#x636E;&#x6E90;&#x62A5;&#x9519;&#x95EE;&#x9898;</a></li><ul><li><span class="title-icon "></span><a href="#&#x73B0;&#x8C61;"><b></b>&#x73B0;&#x8C61;</a></li><li><span class="title-icon "></span><a href="#&#x73AF;&#x5883;&#xFF1A;"><b></b>&#x73AF;&#x5883;&#xFF1A;</a></li><li><span class="title-icon "></span><a href="#&#x62A5;&#x9519;&#x539F;&#x56E0;"><b></b>&#x62A5;&#x9519;&#x539F;&#x56E0;</a></li><li><span class="title-icon "></span><a href="#&#x7B2C;&#x4E00;&#x79CD;&#x89E3;&#x51B3;&#x529E;&#x6CD5;"><b></b>&#x7B2C;&#x4E00;&#x79CD;&#x89E3;&#x51B3;&#x529E;&#x6CD5;</a></li><li><span class="title-icon "></span><a href="#&#x7B2C;&#x4E8C;&#x79CD;&#x89E3;&#x51B3;&#x529E;&#x6CD5;"><b></b>&#x7B2C;&#x4E8C;&#x79CD;&#x89E3;&#x51B3;&#x529E;&#x6CD5;</a></li></ul></ul></div><h1 id="sharding-jdbc-411&#x7248;&#x672C;&#x542F;&#x52A8;&#x6570;&#x636E;&#x6E90;&#x62A5;&#x9519;&#x95EE;&#x9898;"><a name="sharding-jdbc-411&#x7248;&#x672C;&#x542F;&#x52A8;&#x6570;&#x636E;&#x6E90;&#x62A5;&#x9519;&#x95EE;&#x9898;" class="anchor-navigation-ex-anchor" href="#sharding-jdbc-411&#x7248;&#x672C;&#x542F;&#x52A8;&#x6570;&#x636E;&#x6E90;&#x62A5;&#x9519;&#x95EE;&#x9898;"><i class="fa fa-link" aria-hidden="true"></i></a>sharding-jdbc-4.1.1&#x7248;&#x672C;&#x542F;&#x52A8;&#x6570;&#x636E;&#x6E90;&#x62A5;&#x9519;&#x95EE;&#x9898;</h1>
<p><br><br></p>
<h2 id="&#x73B0;&#x8C61;"><a name="&#x73B0;&#x8C61;" class="anchor-navigation-ex-anchor" href="#&#x73B0;&#x8C61;"><i class="fa fa-link" aria-hidden="true"></i></a><strong>&#x73B0;&#x8C61;</strong></h2>
<p><br></p>
<p>springboot&#x642D;&#x5EFA;sharding-jdbc&#x5B9E;&#x73B0;&#x5206;&#x5E93;&#x5206;&#x8868;&#x65F6;&#x62A5;&#x9519;&#xFF1A;</p>
<pre><code class="lang-java">
***************************
APPLICATION FAILED TO START
***************************

Description:

Failed to configure a DataSource: &apos;url&apos; attribute is not specified and no embedded datasource could be configured.

Reason: Failed to determine a suitable driver class


Action:

Consider the following:
    If you want an embedded database (H2, HSQL or Derby), please put it on the classpath.
    If you have database settings to be loaded from a particular profile you may need to activate it (no profiles are currently active).


Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name &apos;dataSource&apos; defined in class path resource [com/alibaba/druid/spring/boot/autoconfigure/DruidDataSourceAutoConfigure.class]: Invocation of init method failed; nested exception is org.springframework.boot.autoconfigure.jdbc.DataSourceProperties$DataSourceBeanCreationException: Failed to determine a suitable driver class
</code></pre>
<p><br></p>
<h2 id="&#x73AF;&#x5883;&#xFF1A;"><a name="&#x73AF;&#x5883;&#xFF1A;" class="anchor-navigation-ex-anchor" href="#&#x73AF;&#x5883;&#xFF1A;"><i class="fa fa-link" aria-hidden="true"></i></a><strong>&#x73AF;&#x5883;&#xFF1A;</strong></h2>
<p><br></p>
<p>sharding-jdbc-4.1.1</p>
<p><br></p>
<pre><code class="lang-xml">

<span class="hljs-tag">&lt;<span class="hljs-name">properties</span>&gt;</span>
    <span class="hljs-tag">&lt;<span class="hljs-name">sharding-jdbc-version</span>&gt;</span>4.1.1<span class="hljs-tag">&lt;/<span class="hljs-name">sharding-jdbc-version</span>&gt;</span>
<span class="hljs-tag">&lt;/<span class="hljs-name">properties</span>&gt;</span>



<span class="hljs-comment">&lt;!-- sharding-jdbc --&gt;</span>
<span class="hljs-tag">&lt;<span class="hljs-name">dependency</span>&gt;</span>
    <span class="hljs-tag">&lt;<span class="hljs-name">groupId</span>&gt;</span>org.apache.shardingsphere<span class="hljs-tag">&lt;/<span class="hljs-name">groupId</span>&gt;</span>
    <span class="hljs-tag">&lt;<span class="hljs-name">artifactId</span>&gt;</span>sharding-jdbc-spring-boot-starter<span class="hljs-tag">&lt;/<span class="hljs-name">artifactId</span>&gt;</span>
    <span class="hljs-tag">&lt;<span class="hljs-name">version</span>&gt;</span>${sharding-jdbc-version}<span class="hljs-tag">&lt;/<span class="hljs-name">version</span>&gt;</span>
<span class="hljs-tag">&lt;/<span class="hljs-name">dependency</span>&gt;</span>

<span class="hljs-tag">&lt;<span class="hljs-name">dependency</span>&gt;</span>
    <span class="hljs-tag">&lt;<span class="hljs-name">groupId</span>&gt;</span>org.apache.shardingsphere<span class="hljs-tag">&lt;/<span class="hljs-name">groupId</span>&gt;</span>
    <span class="hljs-tag">&lt;<span class="hljs-name">artifactId</span>&gt;</span>sharding-jdbc-spring-namespace<span class="hljs-tag">&lt;/<span class="hljs-name">artifactId</span>&gt;</span>
    <span class="hljs-tag">&lt;<span class="hljs-name">version</span>&gt;</span>${sharding-jdbc-version}<span class="hljs-tag">&lt;/<span class="hljs-name">version</span>&gt;</span>
<span class="hljs-tag">&lt;/<span class="hljs-name">dependency</span>&gt;</span>
</code></pre>
<p><br></p>
<h2 id="&#x62A5;&#x9519;&#x539F;&#x56E0;"><a name="&#x62A5;&#x9519;&#x539F;&#x56E0;" class="anchor-navigation-ex-anchor" href="#&#x62A5;&#x9519;&#x539F;&#x56E0;"><i class="fa fa-link" aria-hidden="true"></i></a>&#x62A5;&#x9519;&#x539F;&#x56E0;</h2>
<p><br></p>
<p>&#x662F;sharding-jdbc-4.1.1&#x6700;&#x65B0;&#x7248;&#x672C;spring boot&#x914D;&#x7F6E;&#x7C7B;&#x8BC6;&#x522B;&#x6709;&#x70B9;&#x95EE;&#x9898;&#x5BFC;&#x81F4;</p>
<pre><code class="lang-java">org.apache.shardingsphere.shardingjdbc.spring.boot.SpringBootConfiguration
</code></pre>
<p><br></p>
<h2 id="&#x7B2C;&#x4E00;&#x79CD;&#x89E3;&#x51B3;&#x529E;&#x6CD5;"><a name="&#x7B2C;&#x4E00;&#x79CD;&#x89E3;&#x51B3;&#x529E;&#x6CD5;" class="anchor-navigation-ex-anchor" href="#&#x7B2C;&#x4E00;&#x79CD;&#x89E3;&#x51B3;&#x529E;&#x6CD5;"><i class="fa fa-link" aria-hidden="true"></i></a>&#x7B2C;&#x4E00;&#x79CD;&#x89E3;&#x51B3;&#x529E;&#x6CD5;</h2>
<p><br></p>
<p>&#x628A;&#x7248;&#x672C;&#x6539;&#x4E3A; 4.0.0-RC1</p>
<pre><code class="lang-xml">
<span class="hljs-tag">&lt;<span class="hljs-name">properties</span>&gt;</span>
    <span class="hljs-tag">&lt;<span class="hljs-name">sharding-jdbc-version</span>&gt;</span>4.0.0-RC1<span class="hljs-tag">&lt;/<span class="hljs-name">sharding-jdbc-version</span>&gt;</span>
<span class="hljs-tag">&lt;/<span class="hljs-name">properties</span>&gt;</span>
</code></pre>
<p><br></p>
<h2 id="&#x7B2C;&#x4E8C;&#x79CD;&#x89E3;&#x51B3;&#x529E;&#x6CD5;"><a name="&#x7B2C;&#x4E8C;&#x79CD;&#x89E3;&#x51B3;&#x529E;&#x6CD5;" class="anchor-navigation-ex-anchor" href="#&#x7B2C;&#x4E8C;&#x79CD;&#x89E3;&#x51B3;&#x529E;&#x6CD5;"><i class="fa fa-link" aria-hidden="true"></i></a>&#x7B2C;&#x4E8C;&#x79CD;&#x89E3;&#x51B3;&#x529E;&#x6CD5;</h2>
<p><br></p>
<p>&#x8FD8;&#x662F;&#x4FDD;&#x6301;&#x539F;&#x5148;&#x6700;&#x65B0;&#x7248;&#x672C; 4.1.1</p>
<p>&#x91CD;&#x65B0;&#x5199;&#x4E00;&#x4E2A;&#x914D;&#x7F6E;&#x7C7B;&#xFF0C;&#x5728;&#x81EA;&#x5DF1;&#x5DE5;&#x7A0B;&#x4E2D;&#xFF0C;&#x53EF;&#x4EE5;&#x8DDF;sharding-jdbc-4.1.1&#x6700;&#x65B0;&#x7248;&#x672C;spring boot&#x914D;&#x7F6E;&#x7C7B;&#x5185;&#x5BB9;&#x4E00;&#x81F4;</p>
<pre><code class="lang-java">org.apache.shardingsphere.shardingjdbc.spring.boot.SpringBootConfiguration
</code></pre>
<p><br></p>
<p>&#x6BD4;&#x5982;&#x5728;&#x81EA;&#x5DF1;&#x9879;&#x76EE;&#x5DE5;&#x7A0B;&#x4E0B;&#xFF0C;&#x91CD;&#x65B0;&#x65B0;&#x5EFA;&#x4E00;&#x4E2A;&#x914D;&#x7F6E;&#x7C7B;&#xFF0C;&#x5185;&#x5BB9;&#x8DDF;SpringBootConfiguration&#x7C7B;&#x4E00;&#x81F4;&#xFF0C;&#x5982;&#x4E0B;&#xFF1A;</p>
<pre><code class="lang-java">

<span class="hljs-meta">@Configuration</span>
<span class="hljs-meta">@ComponentScan</span>(<span class="hljs-string">&quot;org.apache.shardingsphere.spring.boot.converter&quot;</span>)
<span class="hljs-meta">@EnableConfigurationProperties</span>({
        SpringBootShardingRuleConfigurationProperties.class,
        SpringBootMasterSlaveRuleConfigurationProperties.class, 
        SpringBootEncryptRuleConfigurationProperties.class,
        SpringBootPropertiesConfigurationProperties.class, 
        SpringBootShadowRuleConfigurationProperties.class})
<span class="hljs-meta">@ConditionalOnProperty</span>(prefix = <span class="hljs-string">&quot;spring.shardingsphere&quot;</span>, name = <span class="hljs-string">&quot;enabled&quot;</span>, havingValue = <span class="hljs-string">&quot;true&quot;</span>, matchIfMissing = <span class="hljs-keyword">true</span>)
<span class="hljs-meta">@AutoConfigureBefore</span>(DataSourceAutoConfiguration.class)
<span class="hljs-meta">@RequiredArgsConstructor</span>
<span class="hljs-keyword">public</span> <span class="hljs-class"><span class="hljs-keyword">class</span> <span class="hljs-title">ShardingJdbcConfig</span> <span class="hljs-keyword">implements</span> <span class="hljs-title">EnvironmentAware</span> </span>{

    <span class="hljs-keyword">private</span> <span class="hljs-keyword">final</span> SpringBootShardingRuleConfigurationProperties shardingRule;

    <span class="hljs-keyword">private</span> <span class="hljs-keyword">final</span> SpringBootMasterSlaveRuleConfigurationProperties masterSlaveRule;

    <span class="hljs-keyword">private</span> <span class="hljs-keyword">final</span> SpringBootEncryptRuleConfigurationProperties encryptRule;

    <span class="hljs-keyword">private</span> <span class="hljs-keyword">final</span> SpringBootShadowRuleConfigurationProperties shadowRule;

    <span class="hljs-keyword">private</span> <span class="hljs-keyword">final</span> SpringBootPropertiesConfigurationProperties props;

    <span class="hljs-keyword">private</span> <span class="hljs-keyword">final</span> Map&lt;String, DataSource&gt; dataSourceMap = <span class="hljs-keyword">new</span> LinkedHashMap&lt;&gt;();

    <span class="hljs-keyword">private</span> <span class="hljs-keyword">final</span> String jndiName = <span class="hljs-string">&quot;jndi-name&quot;</span>;

    <span class="hljs-comment">/**
     * Get sharding data source bean.
     *
     * <span class="hljs-doctag">@return</span> data source bean
     * <span class="hljs-doctag">@throws</span> SQLException SQL exception
     */</span>
    <span class="hljs-meta">@Bean</span>
    <span class="hljs-meta">@ConditionalOnMissingBean</span>(DataSource.class)
    <span class="hljs-meta">@Conditional</span>(ShardingRuleCondition.class)
    <span class="hljs-function"><span class="hljs-keyword">public</span> DataSource <span class="hljs-title">shardingDataSource</span><span class="hljs-params">()</span> <span class="hljs-keyword">throws</span> SQLException </span>{
        <span class="hljs-keyword">return</span> ShardingDataSourceFactory.createDataSource(dataSourceMap, <span class="hljs-keyword">new</span> ShardingRuleConfigurationYamlSwapper().swap(shardingRule), props.getProps());
    }

    <span class="hljs-comment">/**
     * Get master-slave data source bean.
     *
     * <span class="hljs-doctag">@return</span> data source bean
     * <span class="hljs-doctag">@throws</span> SQLException SQL exception
     */</span>
    <span class="hljs-meta">@Bean</span>
    <span class="hljs-meta">@Conditional</span>(MasterSlaveRuleCondition.class)
    <span class="hljs-meta">@ConditionalOnMissingBean</span>(DataSource.class)
    <span class="hljs-function"><span class="hljs-keyword">public</span> DataSource <span class="hljs-title">masterSlaveDataSource</span><span class="hljs-params">()</span> <span class="hljs-keyword">throws</span> SQLException </span>{
        <span class="hljs-keyword">return</span> MasterSlaveDataSourceFactory.createDataSource(dataSourceMap, <span class="hljs-keyword">new</span> MasterSlaveRuleConfigurationYamlSwapper().swap(masterSlaveRule), props.getProps());
    }

    <span class="hljs-comment">/**
     * Get encrypt data source bean.
     *
     * <span class="hljs-doctag">@return</span> data source bean
     * <span class="hljs-doctag">@throws</span> SQLException SQL exception
     */</span>
    <span class="hljs-meta">@Bean</span>
    <span class="hljs-meta">@Conditional</span>(EncryptRuleCondition.class)
    <span class="hljs-meta">@ConditionalOnMissingBean</span>(DataSource.class)
    <span class="hljs-function"><span class="hljs-keyword">public</span> DataSource <span class="hljs-title">encryptDataSource</span><span class="hljs-params">()</span> <span class="hljs-keyword">throws</span> SQLException </span>{
        <span class="hljs-keyword">return</span> EncryptDataSourceFactory.createDataSource(dataSourceMap.values().iterator().next(), <span class="hljs-keyword">new</span> EncryptRuleConfigurationYamlSwapper().swap(encryptRule), props.getProps());
    }

    <span class="hljs-comment">/**
     * Get shadow data source bean.
     *
     * <span class="hljs-doctag">@return</span> data source bean
     * <span class="hljs-doctag">@throws</span> SQLException SQL exception
     */</span>
    <span class="hljs-meta">@Bean</span>
    <span class="hljs-meta">@Conditional</span>(ShadowRuleCondition.class)
    <span class="hljs-meta">@ConditionalOnMissingBean</span>(DataSource.class)
    <span class="hljs-function"><span class="hljs-keyword">public</span> DataSource <span class="hljs-title">shadowDataSource</span><span class="hljs-params">()</span> <span class="hljs-keyword">throws</span> SQLException </span>{
        <span class="hljs-keyword">return</span> ShadowDataSourceFactory.createDataSource(dataSourceMap, <span class="hljs-keyword">new</span> ShadowRuleConfigurationYamlSwapper().swap(shadowRule), props.getProps());
    }

    <span class="hljs-comment">/**
     * Create sharding transaction type scanner.
     *
     * <span class="hljs-doctag">@return</span> sharding transaction type scanner
     */</span>
    <span class="hljs-meta">@Bean</span>
    <span class="hljs-meta">@ConditionalOnMissingBean</span>(ShardingTransactionTypeScanner.class)
    <span class="hljs-function"><span class="hljs-keyword">public</span> ShardingTransactionTypeScanner <span class="hljs-title">shardingTransactionTypeScanner</span><span class="hljs-params">()</span> </span>{
        <span class="hljs-keyword">return</span> <span class="hljs-keyword">new</span> ShardingTransactionTypeScanner();
    }

    <span class="hljs-meta">@Override</span>
    <span class="hljs-function"><span class="hljs-keyword">public</span> <span class="hljs-keyword">final</span> <span class="hljs-keyword">void</span> <span class="hljs-title">setEnvironment</span><span class="hljs-params">(<span class="hljs-keyword">final</span> Environment environment)</span> </span>{
        String prefix = <span class="hljs-string">&quot;spring.shardingsphere.datasource.&quot;</span>;
        <span class="hljs-keyword">for</span> (String each : getDataSourceNames(environment, prefix)) {
            <span class="hljs-keyword">try</span> {
                dataSourceMap.put(each, getDataSource(environment, prefix, each));
            } <span class="hljs-keyword">catch</span> (<span class="hljs-keyword">final</span> ReflectiveOperationException ex) {
                <span class="hljs-keyword">throw</span> <span class="hljs-keyword">new</span> ShardingSphereException(<span class="hljs-string">&quot;Can&apos;t find datasource type!&quot;</span>, ex);
            } <span class="hljs-keyword">catch</span> (<span class="hljs-keyword">final</span> NamingException namingEx) {
                <span class="hljs-keyword">throw</span> <span class="hljs-keyword">new</span> ShardingSphereException(<span class="hljs-string">&quot;Can&apos;t find JNDI datasource!&quot;</span>, namingEx);
            }
        }
    }

    <span class="hljs-function"><span class="hljs-keyword">private</span> List&lt;String&gt; <span class="hljs-title">getDataSourceNames</span><span class="hljs-params">(<span class="hljs-keyword">final</span> Environment environment, <span class="hljs-keyword">final</span> String prefix)</span> </span>{
        StandardEnvironment standardEnv = (StandardEnvironment) environment;
        standardEnv.setIgnoreUnresolvableNestedPlaceholders(<span class="hljs-keyword">true</span>);
        <span class="hljs-keyword">return</span> <span class="hljs-keyword">null</span> == standardEnv.getProperty(prefix + <span class="hljs-string">&quot;name&quot;</span>)
                ? <span class="hljs-keyword">new</span> InlineExpressionParser(standardEnv.getProperty(prefix + <span class="hljs-string">&quot;names&quot;</span>)).splitAndEvaluate() : Collections.singletonList(standardEnv.getProperty(prefix + <span class="hljs-string">&quot;name&quot;</span>));
    }

    <span class="hljs-meta">@SuppressWarnings</span>(<span class="hljs-string">&quot;unchecked&quot;</span>)
    <span class="hljs-function"><span class="hljs-keyword">private</span> DataSource <span class="hljs-title">getDataSource</span><span class="hljs-params">(<span class="hljs-keyword">final</span> Environment environment, <span class="hljs-keyword">final</span> String prefix, <span class="hljs-keyword">final</span> String dataSourceName)</span> <span class="hljs-keyword">throws</span> ReflectiveOperationException, NamingException </span>{
        Map&lt;String, Object&gt; dataSourceProps = PropertyUtil.handle(environment, prefix + dataSourceName.trim(), Map.class);
        Preconditions.checkState(!dataSourceProps.isEmpty(), <span class="hljs-string">&quot;Wrong datasource properties!&quot;</span>);
        <span class="hljs-keyword">if</span> (dataSourceProps.containsKey(jndiName)) {
            <span class="hljs-keyword">return</span> getJndiDataSource(dataSourceProps.get(jndiName).toString());
        }
        DataSource result = DataSourceUtil.getDataSource(dataSourceProps.get(<span class="hljs-string">&quot;type&quot;</span>).toString(), dataSourceProps);
        DataSourcePropertiesSetterHolder.getDataSourcePropertiesSetterByType(dataSourceProps.get(<span class="hljs-string">&quot;type&quot;</span>).toString()).ifPresent(
            dataSourcePropertiesSetter -&gt; dataSourcePropertiesSetter.propertiesSet(environment, prefix, dataSourceName, result));
        <span class="hljs-keyword">return</span> result;
    }

    <span class="hljs-function"><span class="hljs-keyword">private</span> DataSource <span class="hljs-title">getJndiDataSource</span><span class="hljs-params">(<span class="hljs-keyword">final</span> String jndiName)</span> <span class="hljs-keyword">throws</span> NamingException </span>{
        JndiObjectFactoryBean bean = <span class="hljs-keyword">new</span> JndiObjectFactoryBean();
        bean.setResourceRef(<span class="hljs-keyword">true</span>);
        bean.setJndiName(jndiName);
        bean.setProxyInterface(DataSource.class);
        bean.afterPropertiesSet();
        <span class="hljs-keyword">return</span> (DataSource) bean.getObject();
    }
}
</code></pre>
<footer class="page-footer"><span class="copyright">Copyright @copy tianwyam 2021 all right reserved&#xFF0C;powered by Gitbook</span><span class="footer-modification">&#x6700;&#x540E;&#x4FEE;&#x8BA2;&#x65F6;&#x95F4;&#xFF1A;
2021-10-11 20:05:14
</span></footer>
                                
                                </section>
                            
                        </div>
                    </div>
                
            </div>

            
                
                <a href="../tools/github/github_ssh.html" class="navigation navigation-prev navigation-unique" aria-label="Previous page: Github ssh key 解决提交后push频繁输入用户名和密码">
                    <i class="fa fa-angle-left"></i>
                </a>
                
                
            
        
    </div>

    <script>
        var gitbook = gitbook || [];
        gitbook.push(function() {
            gitbook.page.hasChanged({"page":{"title":"sharding-jdbc-4.1.1版本启动数据源报错问题","level":"27.1","depth":1,"previous":{"title":"Github ssh key 解决提交后push频繁输入用户名和密码","level":"26.1","depth":1,"path":"tools/github/github_ssh.md","ref":"tools/github/github_ssh.md","articles":[]},"dir":"ltr"},"config":{"plugins":["-search","-sharing","github","tbfed-pagefooter","splitter","pageview-count","anchor-navigation-ex","chapter-fold","expandable-chapters-small","livereload"],"styles":{"website":"styles/website.css","pdf":"styles/pdf.css","epub":"styles/epub.css","mobi":"styles/mobi.css","ebook":"styles/ebook.css","print":"styles/print.css"},"pluginsConfig":{"tbfed-pagefooter":{"copyright":"Copyright @copy tianwyam 2021","modify_label":"最后修订时间：","modify_format":"YYYY-MM-DD HH:mm:ss"},"chapter-fold":{},"github":{"url":"https://github.com/tianwyam"},"livereload":{},"splitter":{},"lunr":{"maxIndexSize":1000000,"ignoreSpecialCharacters":false},"fontsettings":{"theme":"white","family":"sans","size":2},"highlight":{},"anchor-navigation-ex":{"associatedWithSummary":true,"float":{"floatIcon":"fa fa-navicon","level1Icon":"","level2Icon":"","level3Icon":"","showLevelIcon":false},"mode":"float","multipleH1":true,"pageTop":{"level1Icon":"","level2Icon":"","level3Icon":"","showLevelIcon":false},"printLog":false,"showGoTop":false,"showLevel":false},"pageview-count":{},"expandable-chapters-small":{},"theme-default":{"styles":{"website":"styles/website.css","pdf":"styles/pdf.css","epub":"styles/epub.css","mobi":"styles/mobi.css","ebook":"styles/ebook.css","print":"styles/print.css"},"showLevel":false}},"theme":"default","author":"tianwyam","pdf":{"pageNumbers":true,"fontSize":12,"fontFamily":"Arial","paperSize":"a4","chapterMark":"pagebreak","pageBreaksBefore":"/","margin":{"right":62,"left":62,"top":56,"bottom":56}},"structure":{"langs":"LANGS.md","readme":"README.md","glossary":"GLOSSARY.md","summary":"SUMMARY.md"},"variables":{},"title":"JAVA学习积累","links":{"sidebar":{"博客Blog":"https://blog.csdn.net/mybook201314"}},"gitbook":"*","description":"积累Java学习过程中的知识点，俗话说：好记性不如烂笔头"},"file":{"path":"error/sharding-jdbc-error-datasources.md","mtime":"2021-10-11T12:05:14.106Z","type":"markdown"},"gitbook":{"version":"3.2.3","time":"2021-11-03T12:24:01.188Z"},"basePath":"..","book":{"language":""}});
        });
    </script>
</div>

        
    <script src="../gitbook/gitbook.js"></script>
    <script src="../gitbook/theme.js"></script>
    
        
        <script src="../gitbook/gitbook-plugin-github/plugin.js"></script>
        
    
        
        <script src="../gitbook/gitbook-plugin-splitter/splitter.js"></script>
        
    
        
        <script src="../gitbook/gitbook-plugin-pageview-count/plugin.js"></script>
        
    
        
        <script src="../gitbook/gitbook-plugin-chapter-fold/chapter-fold.js"></script>
        
    
        
        <script src="../gitbook/gitbook-plugin-expandable-chapters-small/expandable-chapters-small.js"></script>
        
    
        
        <script src="../gitbook/gitbook-plugin-livereload/plugin.js"></script>
        
    
        
        <script src="../gitbook/gitbook-plugin-lunr/lunr.min.js"></script>
        
    
        
        <script src="../gitbook/gitbook-plugin-lunr/search-lunr.js"></script>
        
    
        
        <script src="../gitbook/gitbook-plugin-fontsettings/fontsettings.js"></script>
        
    

    </body>
</html>

